package com.poi;

import org.apache.poi.ss.usermodel.Sheet;

import com.poi.util.ExcelUtil;


public class test {

//	public static void main(String[] args) {
//		final Kml kml = new Kml();
//		kml.createAndSetPlacemark()
//		   .withName("London, UK").withOpen(Boolean.TRUE)
//				.createAndSetPoint().addToCoordinates(-0.126236, 51.500152);
//		//marshals to console
////		kml.marshal();
//		//marshals into file
//		try {
//			kml.marshal(new File("HelloKml.kml"));
//		} catch (FileNotFoundException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//	}
	 public static void main(String[] args) {
			int a=0;
	    	String path = "/Users/zcj/Desktop/zjic数据库表设计/zjic数据库表设计overall-外业-总体的副本.xlsx";
	    	try {
	    		Sheet[] sheets = ExcelUtil.getSheet(path);

				  for (int i = 0; i < sheets.length; i++)
			        {
					  a = i;
			            //遍历所有表
					  ExcelUtil.getVals(sheets[i]);
			        }
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				System.out.println("sheets=="+a);

			}
		}

}
